package com.gxa.saas.portal.mapper;

import com.gxa.saas.core.vo.EditOderVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * @Auther: pengxtao
 * @Date: 2022/7/23下午10:06
 */
@Mapper
public interface EditOderMapper {



    @Select("INSERT INTO goods_order(goods_id,pro_num,total_price,order_id,color_name,spe_name) VALUES(#{prId},#{prNum},#{totalPrice},#{oederId},#{colorName},#{speName})")
    public void insertGoodsOder(EditOderVo editOderVo);


    @Select("UPDATE product SET sales=sales+#{prNum} WHERE pr_id=#{prId}")
    public void updateProductSales(EditOderVo editOderVo);
}
